USE TOURS
GO
INSERT INTO [TOURS].[dbo].[Customers]
	VALUES('Le Duc Thuan','0972912123','thuan@gmail.com')
GO

INSERT INTO [TOURS].[dbo].[Hotels]
	VALUES('Ana Mandara Villa Dalat Resort & Spa',400,5,65,'Le Lai Street, Ward 5, Dalat','887-999.09',
	'This 5-star resort offers 7 original French colonial villas ideally nestled on the slopes of Dalat city&rsquo;s rural highlands. It offers extensive spa facilities and a variety of dining options.</p>
<p>Ana Mandara Villas Dalat Resort &amp; Spa offer elegantly furnished villas that include mosquito nets, LCD TVs, and panoramic mountain views. Most villas also include fireplaces and furnished terraces.</p>
<p>The resort&rsquo;s La Cochinchine Spa provides 5 treatment rooms with a wide range of therapeutic treatments including foot massage area and different sauna and steam baths.</p>
<p>Guests can enjoy outdoor barbecues, dining in the privacy of their rooms, or at the resort&rsquo;s Le Petit Dalat Restaurant where Vietnamese and fusion cuisine are served.</p>
<p>Ana Mandara is well placed for guests to enjoy exploring the surrounding landscaped areas and local culture and farming countryside.')

INSERT INTO [TOURS].[dbo].[Hotels]
	VALUES('Sai Gon - Ha Long Hotel',250,4,222,'Ha Long Road, Bai Chay Ward, Quang Ninh Province, Halong','0123 872 1234',
	'Conveniently located, a stroll from various markets and souvenir shops, Sai Gon Ha Long Hotel boasts a spectacular outdoor pool and tennis courts. It offers spacious rooms and free Wi-Fi.</p>
<p>The Sai Gon Hotel is a short drive from the beautiful Halong Bay, while the city centre is within walking distance. It is a 4-hour drive from Noi Bai International Airport.</p>
<p>Bright and airy, rooms feature large windows that present views of Ha Long Bay or neighbouring hills. They are well-equipped with an in-room safe, a fully stocked minibar and a bathtub in bathrooms.</p>
<p>Guests can relax in the jacuzzi or with an indulging massage at Ha Long Sai Gon Hotel. Other recreational facilities include karaoke rooms and a gym.</p>
<p>Elegant Restaurant provides all-day dining, serving up Vietnamese specialities, as well as, Western dishes. Panorama Restaurant boasts an extensive European and Asian menu for guests&rsquo; convenience.')

INSERT INTO [TOURS].[dbo].[Hotels]
	VALUES('Nha Trang Lodge Hotel',200,4,125,'42 Tran Phu, Nha Trang','0972 912 123',
	'Nha Trang Lodge Hotel is located along Nha Trang Beach, 1200 ft from 2/4 Square. It features rooms with free internet access and some with seafront balconies. A spa, pool and casino are available.</p>
<p>Nha Trang Lodge is a 5-minute drive from Nha Trang Train Station. Phu Dong Water Park is one mile away.</p>
<p>Rooms are fully carpeted and come with a flat-screen TV offering cable channels. Each has a balcony and sitting area. A minibar and bathroom toiletries are provided.</p>
<p>Guests can relax with a massage or sauna session or head to the nightclub for some dancing. Currency exchange and car rental services are available at the tour desk. A souvenir shop and business center are available.</p>
<p>European and Asian cuisine can be enjoyed at Nha Trang Lodge Restaurant. Local Vietnamese dishes and seafood is also served.')
GO

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/da-lat-hotel-1.jpg',2,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/da-lat-hotel-2.jpg',2,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/da-lat-hotel-3.jpg',2,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/da-lat-hotel-4.jpg',2,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/da-lat-hotel-5.jpg',2,1)
	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_1.jpg',2,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_2.jpg',2,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_3.jpg',2,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_4.jpg',2,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_5.jpg',2,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/Saigon-halong_6.jpg',2,2)

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/nha-trang-hotel-1.jpg',2,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/nha-trang-hotel-2.jpg',2,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/hotels/nha-trang-hotel-3.jpg',2,3)
	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-1.jpg',3,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-2.jpg',3,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-3.jpg',3,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-4.jpg',3,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-5.jpg',3,1)
	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-1.jpg',3,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-2.jpg',3,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-3.jpg',3,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-4.jpg',3,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-5.jpg',3,2)
	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-1.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-2.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-3.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-4.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/ha-long-tours-5.jpg',3,3)
	

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/nha-trang-tour-1.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/nha-trang-tour-2.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/nha-trang-tour-3.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/nha-trang-tour-4.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/nha-trang-tour-5.jpg',3,3)
	

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/da-lat-tour-1.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/da-lat-tour-2.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/da-lat-tour-3.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/da-lat-tour-4.jpg',3,3)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/landscapes/da-lat-tour-5.jpg',3,3)
	

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/tour-da-lat_1.jpg',1,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/tour-da-lat_2.jpg',1,1)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/tour-da-lat_3.jpg',1,1)
	

INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/vinh-ha-long.jpg',1,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/b4.jpg',1,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/tuan-chau.jpg',1,2)
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/b2.jpg',1,2)


INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/a1.jpg',1,3)	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/a2.jpg',1,3)	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/b2.jpg',1,3)	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/b3.jpg',1,3)	
INSERT INTO [TOURS].[dbo].[Images]
	VALUES('~/img/tours/b4.jpg',1,3)	
GO

INSERT INTO [TOURS].[dbo].[Landscapes]
	VALUES('Ha Long',81,'Perhaps one of the most iconic features of Vietnam, Ha Long Bay is a breathtaking location like no other. With as many a 2,000 limestone islands and rocks, covered with wildlife and filled with caves and grottoes, its UNESCO world heritage status is well deserved.')
INSERT INTO [TOURS].[dbo].[Landscapes]
	VALUES('Nha Trang',75,'Nha Trang, a university town at the mouth of a beautiful bay with a huge sweeping beach, is possibly one of my favourite places in Vietnam - one day I plan to live there!')
INSERT INTO [TOURS].[dbo].[Landscapes]
	VALUES('Da Lat',90,'Dalat is a hilly romantic city with a cool western climate. The French named the city Dalat from the latin Dat Aliis Laetitiam Aliis Temperiem "Giving Pleasure to Some, Freshness to Others", and it is commonly known as the City of Eternal Spring, which has made it a popular destinations for holiday makers who want to beat the heat, and for Vietnamese couples, for whom it is known as the city of love.')

GO

INSERT INTO [TOURS].[dbo].[Tours]
	VALUES('DL727','Da Lat',70,'HCM','Da Lat',5-8-2011,12-8-2011,8,1000,950,'HCM - Ngan Hoa - Da Lat','Plan is here',1)
INSERT INTO [TOURS].[dbo].[Tours]
	VALUES('HL814','Ha Long',70,'Ha Noi','Ha Long',24-8-2011,26-8-2011,2,400,400,' Ha Noi - Yen Tu - Vinh Ha Long - Tuan Chau','Plan is here',1)
INSERT INTO [TOURS].[dbo].[Tours]
	VALUES('NT811','Nha Trang',70,'HCM','Nha Trang',6-8-2011,13-8-2011,7,400,400,'HCM - Nha Trang','Plan is here',1)
GO

INSERT INTO [TOURS].[dbo].[Tour_Hotel]
	VALUES(1,1,65,5-8-2011,12-8-2011,8)
INSERT INTO [TOURS].[dbo].[Tour_Hotel]
	VALUES(2,2,220,24-8-2011,26-8-2011,2)
INSERT INTO [TOURS].[dbo].[Tour_Hotel]
	VALUES(3,3,124,7-8-2011,12-8-2011,5)
GO

INSERT INTO [TOURS].[dbo].[OrderTour]
	VALUES(1,1,4,5,14-08-2011,1)
GO